create  table jms_dm.dm_lmdm_four_segment_push_detail_dt 
(
waybill_no varchar(100) COMMENT '' ,
sign_network_code     varchar(100) COMMENT '签收网点' ,
sign_network_name     varchar(100) COMMENT '签收网点' ,
sign_agent_code       varchar(100) COMMENT ''代理区编码',' ,
sign_agent_name       varchar(100) COMMENT ''代理区名称,',' ,
sign_provider_id       varchar(100) COMMENT ''省份ID',' ,
sign_provider_desc     varchar(100) COMMENT ''省份',' ,
sign_city_id           varchar(100) COMMENT ''城市ID',' ,
sign_city_desc         varchar(100) COMMENT ''城市',' ,
terminal_dispatch_code  varchar(100) COMMENT ''面单三短码',' ,
is_deliver           varchar(100) COMMENT '是否出仓' ,
deliver_third_code  varchar(100) COMMENT '出仓业务员三段码' ,
third_code             varchar(100) COMMENT '驿站补推三段码' ,
courier_station_code    varchar(100) COMMENT '驿站码编码' ,
station_unique_number     bigint COMMENT '驿站码唯一标识' ,
is_txd   varchar(100) COMMENT '是否推送桃花岛' ,
is_qxt   varchar(100) COMMENT '是否推送七星潭' ,
is_jms  varchar(100) COMMENT '是否推JMS' ,
input_type   varchar(100) COMMENT ''补推来源'' ,
input_type_name   varchar(100) COMMENT ''补推来源'' ,
date_time   timestamp COMMENT '查询日期' ,
 varchar(100) COMMENT '' )
ENGINE=OLAP
DUPLICATE KEY(填写key)
comment 'insert overwrite table jms_dm.dm_lmdm_four_segment_push_detail_dt partition (dt)'
PARTITION BY RANGE (date_time) ( 
   START ("2023-07-10") END ("2023-09-08") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(site_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);